SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343932 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343932 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605056,583696,358251,721302,1011115,648223,368858,237224,249561,100743,358091,738087,208652,479816,334784,98588,235901,500700,601739,627232,367283,273913,602357,489100,386690,853574,1008337,121044,310073,100269,695292,573040,1022433,1037457,729146,572807,112587,367296,1011489,699975,901982,112359,398010,877502,910527,575274,496506,830984,897484,546658,282464,721256,622996,284640,1006500,873800,553870,952694,804885,690475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343932 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343932 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]