SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016231 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016231 [ RunTime:0.002147s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330523,710009,758544,564780,522077,450855,1012194,263877,846638,615965,981791,696176,210635,764257,847283,661433,386280,492848,851609,1021443,746502,710459,558082,728886,947609,323134,498526,915814,235881,220107,734246,385437,551088,321909,860620,252448,119050,291793,116700,43143,587367,123315,725653,265773,645752,617110,24266,745819,425490,207396,1017814,1015225,717522,26374,815665,144818,525972,638476,703412,463212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]