SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596635 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596635 [ RunTime:0.003282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338526,25466,92229,618448,155747,515006,599058,667894,608059,607383,462057,868388,688612,82558,90888,887923,134108,452079,724709,401119,220335,239845,495333,134324,319185,565464,934310,824125,9834,46946,664227,1020257,369493,239338,1005052,142865,516064,1044679,109751,615894,745106,244655,416075,714388,521906,461075,239557,339741,334302,108768,210870,12624,1043777,960985,470607,163776,581532,640079,79917,958057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596635 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596635 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]