SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452401 LIMIT 1 [ RunTime:0.007581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452401 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71698,561544,695199,801480,782124,440893,384170,592305,397793,737651,1024109,776801,468251,206257,370316,786550,637964,151772,17555,209404,327761,421696,323539,703129,513502,118628,527160,405973,499766,967067,493449,705670,322789,81585,185641,387671,489353,76042,954806,868750,510924,304225,258200,520352,140921,692384,20009,321930,527408,162171,568149,105285,544343,246588,921945,701662,184437,890765,27609,947162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000927s ]