SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428633 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428633 [ RunTime:0.003527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968869,458990,967090,245314,160809,1001341,1025496,198329,668774,203517,1036010,653738,266050,95480,403486,823056,165627,257736,1023667,575138,50730,170552,229445,155386,389754,290069,193645,196940,831004,636569,808375,28267,940286,90999,260087,832612,555913,284270,807950,14579,889240,287146,444118,612141,364741,572481,246918,176399,685548,104904,675933,890934,420190,67081,813621,404490,662387,57944,139587,746732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]