SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520888 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520888 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614070,480737,1021852,1007176,503697,442262,972658,175204,929679,431562,175,162156,820085,636359,272328,189238,79768,352295,878663,471640,387538,443382,470271,373830,1011185,502105,950022,221226,978944,897523,219591,818261,682078,904272,603871,890280,816644,295422,622908,971558,9537,1036260,74364,974297,666023,241649,188280,733857,1039394,96010,1011429,757343,773159,228465,70653,214165,491628,498833,1034845,1000081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]