SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021083 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021083 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570456,477473,520448,208776,96342,55160,743403,282978,741011,550919,428968,393395,1021200,958343,925281,700171,59322,610979,646682,332118,70312,1010470,1018535,902131,383785,835410,1033651,811800,81202,679883,1035871,356872,443598,606074,523179,217621,510483,728216,154496,736060,299786,975084,383978,424280,180123,866644,316716,259222,15145,937745,117471,181807,921773,939273,21978,1030271,931,183170,361682,1027660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]