SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438519 LIMIT 1 [ RunTime:0.002392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438519 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81894,171744,956966,1029710,471299,401986,41067,153498,1007010,942108,505822,245512,800077,1041288,742071,696585,528023,343165,491210,881481,411474,176000,879638,221738,241131,80585,439928,590730,329690,1039262,643721,681444,1007247,934327,439012,423092,211,697978,605617,750724,766607,241551,460840,201726,635407,798247,1001266,183753,208652,717106,123605,390064,733226,518184,824432,333182,238750,409104,890691,504500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]