SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512268 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512268 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028682,54652,535008,711500,985362,329364,27370,624295,248564,703111,202076,44686,52525,713712,799979,572458,910565,988905,869118,933215,599979,274108,665289,943103,440107,800781,371275,154797,384829,123924,596970,533811,925374,789614,112178,143406,331186,759931,929854,277698,6888,452268,885007,558777,699191,85588,236507,693040,434260,721371,698253,903414,315858,647118,225043,249515,987484,428115,251920,127207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]