SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005227 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005227 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185038,832768,510084,169999,205601,591049,909397,208070,289915,180999,230550,603237,751539,827519,300191,600577,32895,131990,562978,3173,508864,540069,166158,1019342,662524,899381,295919,802258,632487,349354,624875,1397,677539,754951,118776,662292,530833,514048,784918,510757,928567,54756,276838,420259,1028544,337591,544191,416959,510647,292075,215881,379834,730175,1032634,513911,1008102,975959,532777,314326,12385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]