SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023516 LIMIT 1 [ RunTime:0.001207s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023516 [ RunTime:0.002200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436155,335581,67780,774269,980451,572188,565442,267039,37563,658025,549398,681668,730089,3670,162616,1028057,893654,218346,699229,19032,963207,488459,491343,513262,522014,659274,195075,326072,458130,104861,678122,1030972,960794,629168,794148,310472,92316,991179,751523,68360,896358,950880,292128,453615,907182,262219,302802,148098,988397,838576,169725,82208,1026816,506002,714386,814711,657183,66665,920421,937310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000884s ]