SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516180 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516180 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719638,849007,1019986,1027376,215444,439871,191532,235913,310025,981299,780980,113729,808382,994599,336368,25755,80780,204783,370533,73878,805227,499820,21421,1048055,288712,384429,223249,559756,745879,957410,880683,88635,314133,606114,825098,114859,326371,792456,407492,801156,569660,519619,278783,312954,630807,558479,992091,259221,310050,916720,236154,681996,578570,304045,2569,294617,941872,886936,40657,717000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]