SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143704 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143704 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421743,308120,420281,684473,1006469,183731,470754,704258,142916,856789,885004,917429,713080,991932,104634,656133,751041,273346,310750,292405,516821,689401,1023913,848030,527471,140453,748374,214666,680307,69989,582584,235197,541146,866904,138433,370116,216667,98894,802148,74815,440994,115208,538291,380104,427533,36523,992292,631715,59889,488784,610344,922655,120070,357702,1013604,595353,747487,404357,241777,502818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]