SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034007 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034007 [ RunTime:0.003225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430484,936138,439687,103092,157457,165630,833993,287836,756475,901529,660434,844822,144165,606195,298971,579026,590319,704265,693073,347280,281883,196096,879568,573278,109784,1001098,985208,241760,190431,554415,756661,189512,112879,69785,6570,446474,916187,992734,101382,589179,413523,956050,557987,190879,95957,245305,167692,967593,185181,229794,784183,902599,12165,419965,1042363,824732,593808,678798,168944,613218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]