SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44770 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44770 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826132,837914,151005,1046933,690510,400902,366655,25873,343651,154917,101790,267771,113803,299691,347211,512369,924100,733136,425671,449084,503312,10383,798505,245410,530878,36231,168692,112369,728939,384729,572507,655650,851614,502913,868347,467019,61856,678272,1023440,308151,805700,1013059,981530,746435,964041,942585,330566,799730,450273,101045,344283,557866,421265,833194,637422,389098,741711,645065,382399,423486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]