SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806408 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806408 [ RunTime:0.002429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447128,755505,573222,564514,826865,862267,450431,564958,127380,48375,946168,341602,129177,261317,53141,835106,310185,683297,826430,838429,444066,749167,222498,888881,851900,658285,727317,405950,119640,486424,764740,877866,69418,102879,612664,704886,735810,160879,1041623,609385,346619,477675,489890,492431,798186,961014,618671,1043915,488239,41718,543900,566120,21987,632597,226963,724216,599156,911069,802675,482130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000667s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000991s ]