SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26673 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26673 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751644,811022,348973,806545,977294,535597,441737,230793,137138,704569,391820,547029,673254,207694,567214,369537,949416,436479,855705,41306,625044,323945,231934,209019,866778,621330,476848,743653,554219,339714,1011932,199440,554552,942751,394285,158826,203015,695985,1035296,850965,4848,814632,25614,708626,1040750,894718,709541,190164,410198,560835,607499,110164,858602,352744,308407,479446,535832,754237,581865,784505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]