SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001578s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562940 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562940 [ RunTime:0.004328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722035,365847,668779,21351,209828,222474,934353,267351,309820,111577,720302,12493,269377,633691,581710,852839,415598,580213,833954,696344,936182,390044,401240,93534,715748,549328,925652,3029,598832,477005,98845,317950,157064,280658,109580,622810,247710,851070,963863,41239,98983,43964,71458,996218,219045,954572,5506,802430,316047,720174,738666,410576,788674,87240,779943,137074,550475,43300,21226,427532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]