SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020416 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020416 [ RunTime:0.002916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045835,239992,230075,32368,625842,927142,332529,320587,1026337,728269,555037,588378,815814,13061,201351,539821,110106,655793,651354,244916,485579,646756,146959,884491,559231,662563,123546,624459,860743,590174,118666,503649,612069,469926,945924,594979,670820,269191,274723,355530,678634,360580,840284,377912,695787,100414,543685,957196,1047496,1004111,764800,505161,480279,394667,174616,780123,564029,337721,344614,124233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]