SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480809 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480809 [ RunTime:0.005608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371370,487329,256398,1034790,665778,54451,365441,219983,300002,1029272,396072,157265,230303,419762,240271,685229,59419,562215,998920,948207,204460,533383,505382,577548,273966,140442,178648,310427,12601,1016926,104723,506517,346713,501283,623816,293582,486399,522139,264148,243089,721172,482087,719671,80453,402689,319715,38294,494696,502024,384895,920874,89450,983373,17819,821385,1040299,961422,86487,355183,845919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]