SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51142 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51142 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (942573,524076,484939,368033,699419,277098,544217,745927,947805,449735,170851,536205,1040269,410851,926246,601913,1032169,572921,881930,269650,501633,914056,925645,488304,530024,194413,1024104,256248,115428,758809,215041,389818,586558,550140,1012086,71370,579506,293081,51921,123223,830284,144860,614409,625139,468304,223477,788038,229517,1043710,912564,941477,442494,386244,191213,181885,358429,127970,257940,676539,442600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000807s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]