SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107207 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107207 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50010,697820,118440,25648,242298,213099,894573,183311,519435,99832,843727,148847,829777,729567,643441,869618,586226,618728,658982,499905,535478,322509,233212,574702,200215,589177,200991,18995,975065,412118,795059,730877,630488,12072,6906,430382,1007728,455168,1038074,391626,997590,456137,856356,474332,512214,769184,498579,80697,752706,421262,1039049,126773,615708,420454,993559,509435,553048,891374,360493,303131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]