SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041882 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041882 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190513,716514,205910,514183,664575,680837,1023196,561758,413642,869200,331707,364650,132834,89224,719032,264417,800043,367561,974317,744336,643212,561291,8742,921399,395943,817399,737561,668023,7206,132461,10586,300191,972254,305223,541527,786980,230951,98768,90902,22910,205414,227230,557556,615413,521715,835448,733515,927933,341029,510311,166999,877417,359258,304663,95124,246861,735033,251448,650762,822993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]