SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 930743 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 930743 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771042,637391,806080,400001,850289,715437,291904,204842,446788,517451,159931,770651,360789,817141,125912,3621,25309,787914,705346,742925,507423,157613,698038,171485,558464,497681,578073,986383,821810,121312,437155,584383,989408,967354,1028699,38921,317821,980161,323899,478940,208154,589827,129539,758836,1027843,102402,48946,440072,967746,195336,1030385,254435,959061,973189,91632,932280,1044806,412136,895463,778788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 930743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 930743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]