SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467545 LIMIT 1 [ RunTime:0.002334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467545 [ RunTime:0.010048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836414,916397,1004360,873496,450386,681433,600688,658663,699202,549288,354824,807459,483240,343694,207346,265728,106125,411404,889115,24056,1032498,147204,130261,902828,435364,161155,778789,287221,854665,925336,806412,623132,953953,499870,949675,586464,23360,492178,360642,443656,662521,261853,581468,71782,720556,136236,684072,276476,845823,648880,217205,855616,39876,267499,469729,45026,200978,995489,762521,167704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001458s ]