SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598731 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598731 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61302,481616,896965,262908,249102,1038917,1043262,372972,399962,279197,26187,187773,984076,601264,562179,270772,820722,261010,511050,464820,1008226,431711,374175,754623,84997,190274,607569,899239,225038,69395,773072,698665,613050,612692,401143,108494,477534,367447,193865,320739,209794,172065,868180,919985,351916,717404,609587,647560,101275,140243,100060,531466,611298,174286,499069,499861,523221,364179,4846,681076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]