SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416060 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416060 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819141,545086,360395,788570,578502,290876,548989,833347,331504,40229,630886,872087,280596,993018,471605,883170,364632,466346,841042,699311,436737,830020,243118,404344,607443,630626,44129,561073,148421,437028,247682,870859,727587,72096,71915,942159,378420,270032,987045,138834,739868,714049,628486,300999,515455,976601,496366,135252,363301,27938,297808,540015,834111,572343,934354,298370,543563,233744,841146,1044712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]