SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504031 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504031 [ RunTime:0.003469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279534,312313,1010929,379105,697850,552425,356192,368340,515790,1020281,266267,665876,413385,668994,422107,788547,851538,392145,105125,965518,29088,722205,396106,804881,246023,998256,226200,415093,864668,48180,623637,317930,550662,610423,878464,399542,247262,176797,825254,60752,491106,155069,96688,907354,647277,133806,647820,800424,524350,346356,98961,848158,176178,891297,897526,74904,534442,154827,808709,563201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]