SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447840 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447840 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681637,345945,42439,486289,173624,994329,469170,760564,368221,9802,600606,1028099,852964,517273,409975,262290,984167,604297,879006,113250,553356,335490,782089,508959,362978,685383,32596,874981,408184,992490,348593,400803,130252,42755,1020877,29005,740904,681377,932204,823103,394349,280586,144883,1006941,217283,527984,656130,288489,667020,756384,532456,789056,678478,120579,110909,70653,184479,112804,368734,83745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001647s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]