SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254574 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254574 [ RunTime:0.005460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256066,763323,779891,15044,782884,376119,766547,948140,184062,38825,223139,36812,574886,529292,1045556,748653,873059,161928,1039424,389037,34031,472693,410061,436931,1026616,741221,62008,659234,1008078,531603,349038,69149,205157,972255,112054,632272,905309,79852,170232,705835,92954,635740,91831,430740,263394,858809,183834,240971,481089,130048,471212,820988,494760,593618,203472,147843,19182,452149,566632,512696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]