SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518583 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518583 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674964,819646,706665,193432,489139,198738,890194,592710,819916,329369,546961,485793,767591,684567,581515,630866,688532,586340,142026,232356,1025572,279131,488460,768610,798477,127599,646749,698318,376383,967731,434238,533824,539632,601303,116736,201434,731205,835520,969438,774371,17497,79449,420985,449594,219203,481131,418225,682882,1045313,299154,374327,809676,91007,158834,177540,112933,819190,963418,749372,110588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]