SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482563 LIMIT 1 [ RunTime:0.003913s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482563 [ RunTime:0.005902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611237,410008,672575,146163,905808,723504,760083,545437,36830,59721,209491,673947,486981,112683,695902,108748,287590,307531,590721,1026108,195510,766116,344545,619671,880257,391392,922541,334510,140598,606517,209723,206514,701040,38719,130400,660699,193818,151372,475444,43200,383176,251866,730779,425444,345918,360972,423568,400598,136300,290212,344313,87389,450337,780829,80723,369940,256059,951354,750005,272379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001353s ]