SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515571 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515571 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925282,382084,97591,31892,962249,1013046,876050,109969,461284,349064,1012652,130376,181857,349101,575739,500575,158313,923043,834633,155142,1031039,64650,407890,195863,420259,859398,1029770,784709,500354,36499,780157,501011,341202,157344,160131,288707,663010,71772,96385,39205,1018699,623405,133255,691737,708835,264777,156846,1043613,369442,815384,538199,222223,166908,98930,409390,35697,56062,3709,901041,488273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]