SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310940 LIMIT 1 [ RunTime:0.002689s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310940 [ RunTime:0.005741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217049,614884,496972,619499,427711,394046,777193,568833,359902,414547,749998,985483,925414,342049,601675,106270,722486,888376,424112,441957,553652,651658,192489,83767,853316,865845,710507,416404,1047663,459198,52827,995596,844016,980643,266990,467700,981105,843295,812783,348440,1048437,172461,680229,381940,749677,153838,549092,777033,269919,850242,601717,35374,772694,680969,758713,1008068,15167,75810,974688,749440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]