SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201459 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201459 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276952,643644,11885,81235,705247,455186,1009979,1040637,55844,331049,194099,982681,184460,402490,968614,497006,275891,430241,50635,590852,142578,646041,162667,306263,985365,217354,707298,894984,787588,1042287,338653,910467,360705,897082,363383,948372,563627,951972,553872,463492,819234,91079,114823,810589,34638,801966,699426,822835,496790,503232,667102,210058,621285,993703,859047,360100,3620,282194,318385,1011039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]