SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501375 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501375 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637564,386241,933500,451167,125798,970479,540368,335221,645733,439011,448400,312060,64621,265805,578208,768651,354087,370482,558713,399212,911546,594019,818133,338212,10983,500559,501659,36671,334864,603911,394278,243185,105461,114387,534549,869471,294147,291936,181988,110127,252375,577222,501178,1034396,764000,950961,423017,204197,884987,263310,272396,339368,608252,814023,386593,944256,868681,463509,751068,704413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000648s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]