SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545040 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545040 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169217,574445,130025,954973,51599,533571,628317,866466,931911,818328,131114,225151,279687,26395,185555,197552,17319,1046702,48717,818738,309999,513963,750825,572140,66413,835280,603307,62456,749130,718812,56064,939397,377372,599813,457771,908576,32374,660328,249728,651705,427078,385629,412317,667547,11904,573605,657553,97661,901155,581734,480800,86350,439445,603711,219093,449345,438671,301022,1010862,710838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]