SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413880 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413880 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588177,652688,454295,1048203,79737,576761,651611,900097,167659,746172,532676,480190,887691,513257,552532,257373,815194,659443,118447,721772,912662,103939,164608,209290,478739,1003220,231919,310948,469423,148784,5325,108959,236330,232406,970576,1017353,473737,223350,815713,174784,1038182,779402,354060,877199,651252,518047,309347,742370,450588,420602,1047687,976295,517919,719473,950365,1047614,121837,258308,311219,935233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]