SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812208 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812208 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55115,93802,37038,757551,632947,536518,867620,684744,132268,907068,491761,575675,582694,133999,1043902,720918,548610,604453,307209,517739,632682,833227,166858,573625,71305,543336,21252,101927,215933,214233,1016670,196022,201567,196830,274699,396670,362430,304902,906225,73199,24299,241915,351447,28346,250797,1048407,197455,944863,22670,107293,687108,1031971,416063,236981,521078,522701,1010188,788530,364300,846049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]