SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 80428 LIMIT 1 [ RunTime:0.001070s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 80428 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (552759,682498,140269,940104,327455,330602,210585,724780,768607,186680,91958,373270,239236,545060,276030,234655,636755,722734,273434,368037,909076,860569,446770,792943,285167,944257,91966,38203,646849,1038968,104072,197949,625835,212052,737008,840118,1044007,141903,888130,917510,283287,456603,17449,1032642,645429,940719,293508,449172,606440,178439,615070,593963,497391,743337,767652,344756,1013062,281408,41513,159352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 80428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 80428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]