SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523522 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523522 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657335,43802,224087,461640,786409,842230,342029,1010483,402011,77747,187992,572860,103824,769679,396216,406073,936086,230225,623528,73260,508684,607357,994722,605605,420893,327484,355072,700173,150672,946965,952250,3387,576914,962024,18111,551947,292758,800010,485185,715578,387620,656970,844295,919142,349267,280722,328952,588836,255484,542703,416079,226661,189300,687788,948177,421322,944389,126410,1022463,566986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]