SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415591 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415591 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403880,284218,49290,337742,964,50181,266021,760284,565240,532712,836658,949480,213273,883090,878319,181357,547423,1652,738128,85621,842663,394370,134734,325089,4399,739425,828974,860705,705885,280681,17639,608830,443171,985925,380881,668105,874911,449053,602551,448676,525920,837397,850858,958014,970433,534615,1023167,400384,552024,237556,862161,393968,622423,1006032,313915,171148,433932,35744,989202,166501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]