SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024891 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024891 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253930,251892,12704,792558,94545,173729,72443,206830,1009014,565014,426837,605432,210301,158852,451974,457513,895144,611351,11710,856041,795998,199326,18784,782112,846673,140523,203313,94295,926512,855921,814882,218195,64765,69297,766407,968282,204781,88148,220756,1011149,594781,712514,841875,795803,866451,812690,85848,205990,52531,138580,1038172,994093,169280,817835,999713,444648,329403,187301,954204,934726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]