SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343395 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343395 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022132,291154,486776,930165,422843,547735,53713,601019,814452,216060,439943,957194,502175,457592,63299,627758,46361,359358,377209,571359,388756,243442,766882,492683,659754,117561,877813,829310,553746,66859,679205,131915,172699,538339,908800,20300,124206,672976,195705,1034110,824723,30020,746515,417175,435909,658159,1001140,363857,796093,510213,180463,558445,355167,104664,987927,473253,489495,882725,573147,159862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]