SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402078 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402078 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156481,110081,1043611,40861,339302,1026184,624973,163947,682641,574662,448391,388498,786872,166571,544294,708895,928020,75139,255180,909394,601329,373562,302263,160519,863185,586304,559768,524774,539912,921771,320129,909143,595388,328467,53089,16318,957,499660,716095,551581,68939,725285,813376,494124,969331,494989,989790,144408,875064,470940,26996,986100,336253,910073,702422,553856,13447,663259,667063,46810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]