SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534540 LIMIT 1 [ RunTime:0.000798s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534540 [ RunTime:0.002993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578143,621901,45700,1011168,150566,412902,128805,964621,186314,541641,325451,928829,271863,101811,102438,97548,168770,806203,573384,179601,542563,746511,535882,425346,168315,852377,807994,612301,1027287,168143,1001904,74473,672237,820685,478532,901804,565647,779607,71443,165838,831676,492231,679827,592443,1040528,144825,220363,623305,253288,306791,58622,706028,955084,300718,960206,366100,1036436,109548,171832,538183) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003111s ]