SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003407s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402728 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402728 [ RunTime:0.004128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193829,100091,207679,22539,716306,659814,966865,189388,673093,213109,737258,478922,277644,874117,259244,600265,405511,315097,742292,874476,174058,158618,362326,842291,973412,943598,598575,672365,22914,968677,330009,699862,761378,264943,374614,618534,674032,607729,626385,400286,15263,989087,824837,678265,645612,1012475,869104,99318,716019,510902,55170,911204,60347,712479,681469,919626,820583,522308,10699,423484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003605s ]