SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54708 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54708 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699929,947308,886691,852417,634180,178856,428934,160541,234509,252999,620279,170503,681533,466021,323981,907226,168152,560097,90653,687939,854298,955689,57372,261302,591874,113124,542578,163258,82370,949468,294527,478577,48176,936478,819254,219141,359316,102036,22324,239128,749798,184987,615548,450750,349452,241111,863288,805540,659165,253496,334861,1012741,886122,177981,998885,606779,131046,1004629,540156,249603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]