SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452210 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452210 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643627,338858,216075,566298,809017,788599,465087,45538,303021,175903,580365,836746,245011,517143,320133,961629,481777,304410,663486,443492,35618,1002493,385605,180131,728264,528995,402500,1017919,949942,383176,271005,424955,882643,589379,983070,603281,425304,406157,72018,78490,504513,1007843,100722,798154,821886,258124,712705,220285,1031337,1422,443170,568083,826185,140291,259518,799482,90172,306616,943201,1010221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]