SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413211 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413211 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711694,231040,733287,584472,909567,802614,988837,17819,213822,687158,940052,43464,800213,706682,170713,530349,763927,479229,85899,411225,213032,103946,186776,467097,672440,107552,366964,269322,998159,61148,287503,932982,106883,1024497,858112,907539,655748,500876,448604,692549,611869,764007,104839,656841,683448,33674,598666,978637,248257,801326,937216,862780,460390,47794,569928,418227,93150,62948,575897,821852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]