SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148104 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148104 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354798,386454,60879,80704,940312,706634,217868,500643,632257,821905,396288,227873,334077,640510,15064,686426,969470,255269,92701,406390,1031602,198218,277104,67945,593803,984231,28825,591627,594801,186240,321984,373353,996000,594613,866047,1015601,703701,41585,492296,987761,380970,334402,736505,1034119,225515,886774,897533,349213,863895,240869,294270,142171,580089,576681,660958,924476,419505,516037,5307,165992) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001460s ]