SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452095 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452095 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113320,860301,965346,991423,149894,811677,201443,782368,1022890,111283,690049,395552,246339,518181,681039,537137,730529,1018824,919828,85436,965224,488259,107953,303179,837920,730101,647735,583689,886229,135305,356281,327979,755940,303851,133145,523587,258016,850363,952848,820228,53392,421675,976052,610838,130600,731459,469362,321720,209177,46052,405765,187677,121360,54391,1023743,455168,221315,907864,759196,737671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]