SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534421 LIMIT 1 [ RunTime:0.001481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534421 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492003,215778,551035,687060,196739,850710,600282,461491,455068,667171,1034315,722523,892714,308014,423013,756453,471894,895633,633944,109235,878330,61380,98158,547428,325657,902601,142915,391276,756241,16860,225382,912482,935112,143444,445314,891831,362333,570747,4172,7346,901788,106099,151419,197346,426789,80926,423733,43791,230936,715911,462842,1010737,1038236,747887,287896,652050,387374,156602,31040,639842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004880s ]