SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521023 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521023 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840280,619457,49619,762062,380671,718785,468918,374355,717435,893423,8754,225937,538908,849297,890431,996021,143735,998197,49727,1015299,641262,152862,850002,539861,231911,334592,679766,8866,152457,1004741,119388,239476,60435,644612,732963,984386,655800,986638,667563,285236,851039,129042,265081,704356,192968,274452,515013,952102,33740,397692,25320,704813,65009,125002,365448,846366,502559,1000475,835940,282669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]