SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506185 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506185 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798032,337136,129817,163116,452362,431195,380832,1025248,733106,275179,474842,109308,559200,456507,198273,576655,85043,385410,978009,441331,938977,294054,497175,487223,338680,965725,236855,387241,245005,1003810,780,399445,98105,62251,686618,902866,573311,595863,697934,728732,706691,201264,400460,179669,772453,839530,765103,646198,132227,311724,548937,712969,955397,1027998,1012520,393378,397478,117575,880454,398013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]