SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429973 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429973 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275811,733023,402152,925533,39300,413441,404058,557501,868381,838634,7945,448657,362690,277735,338301,102339,163312,59357,259560,899645,64913,378645,810253,339066,815459,717850,852056,93477,302631,904429,1390,646115,229392,663290,752854,202694,345471,664858,254328,704138,341485,742999,839469,134151,390549,41812,107391,646225,373702,166660,789758,204332,534032,717144,423683,645395,990127,653227,113462,645772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]