SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297513 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297513 [ RunTime:0.002416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458173,463372,865377,999916,83189,652375,396898,301000,331456,564370,915259,348686,969521,76211,512812,895206,840238,103100,193177,649063,223370,186461,356654,218539,177487,247532,308129,334523,553728,19493,360234,396818,436603,473296,101654,564366,751494,868215,105314,997434,774738,351217,957887,833498,230683,821612,269486,320111,861148,1032311,307618,469505,872132,602462,430656,84601,498086,890892,138061,783940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]