SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426101 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426101 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146167,205140,56672,998571,463523,710941,80433,1036866,907000,438840,124705,562087,745840,867286,668408,1006894,977608,400251,298884,818509,620501,720250,47678,149120,723125,667760,469772,760571,776854,461941,161791,322809,762307,765002,863196,730314,358801,514454,502194,936246,553031,600911,187567,973395,655848,444856,803877,529478,1044550,281628,215176,872487,452418,461485,515245,970945,567994,675769,342052,336702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]