SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546964 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546964 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533320,296029,929597,701560,327237,777782,166118,622990,24051,946590,981547,931048,102111,585050,123245,359948,37951,744477,771336,249272,90962,10141,252397,661839,396857,580268,155170,459438,763651,344259,1046148,201993,705129,753262,760527,62036,970720,890548,509718,813346,50461,431891,107565,954795,929862,1031240,927685,476198,569747,681968,1006554,712428,200345,723949,944157,288320,812952,838712,509393,336696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]