SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 660083 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 660083 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801040,141447,312909,281181,1039866,814182,54907,848508,1044880,471959,668055,191592,519289,210103,484466,621164,96785,1024517,883838,861881,541134,134795,294426,868737,218569,655870,84532,1038442,623177,63179,891874,559583,211669,888724,680951,394620,282957,255615,549170,381993,750184,916569,955528,772760,724147,845601,563629,191099,737545,699917,136585,168986,444718,523699,13520,961091,267416,897651,195168,877843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 660083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 660083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]