SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007498 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007498 [ RunTime:0.002574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532586,1006054,145803,312827,17605,89923,73504,1030900,719869,923282,818362,667091,318807,635140,1006675,631642,577846,751739,604955,11451,777958,671853,122574,271441,717108,602352,58662,180294,408173,845513,631451,682307,922313,689060,768351,942525,315198,47331,303157,401276,340699,40804,500168,930395,87939,601576,1011961,2859,937559,896691,893780,388695,802218,483054,231946,671673,61570,661903,790391,346018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]