SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117180 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117180 [ RunTime:0.002548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679405,11793,153578,641992,661622,80029,956923,866421,488287,684152,97577,719398,421311,96551,1002152,148693,196929,550410,421035,555589,724964,725434,638458,504773,1013484,357870,617651,483694,76758,380252,999671,407851,969693,683447,547821,666169,559207,344160,2891,82083,985090,11643,323791,143029,90478,484278,259848,180670,45048,802215,477109,298241,376702,967373,605781,440045,153818,717785,977961,130062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 117180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 117180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]