SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546025 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546025 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104678,694387,504606,416640,438459,510011,406207,2503,561521,58057,207868,860514,674373,880827,420318,237483,694411,750591,858415,358025,833812,789758,937388,203239,731845,750840,1022176,256567,180117,541722,801949,180758,263936,205626,289254,319712,589321,464950,751248,762267,454064,1035247,347342,372985,611964,260122,211138,992674,224552,510403,165858,1034922,428394,802641,259531,392036,754287,859977,325153,311947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]