SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901018 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901018 [ RunTime:0.002204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649637,1028695,83759,359417,305355,188589,402860,813416,492787,227756,193237,328452,812013,256251,425950,28721,88252,755412,1017102,778228,739489,866915,251060,634740,102896,1031564,596032,456267,545314,793238,599128,270106,59264,1023767,988681,1042994,795064,49892,609782,751187,315136,7782,105057,640852,921453,451129,924956,67528,1021701,308760,412437,49659,177455,897912,562714,760503,557396,713360,861796,559067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]