SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269851 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269851 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409477,416835,37351,957899,46691,500749,991999,563216,376722,580102,135322,403511,44910,933989,931140,183449,494032,461772,195122,1021117,325194,670836,132990,574662,384050,377157,899108,492699,239336,199000,540541,550387,671677,592492,566146,540775,140019,679826,321347,201546,296769,893177,384549,888827,905614,1019072,804453,883828,423624,641685,638289,700037,355691,376711,875020,660445,482494,79924,975838,218932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]