SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418728 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418728 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32907,517200,453449,723948,772649,401562,427877,739070,130016,1013337,886561,723489,741290,332714,700732,322737,751768,71838,356482,773069,916527,116876,894572,749431,268531,1048155,385815,312276,823217,602974,701312,828226,919338,135752,7198,181842,693525,189733,519470,505848,656831,65923,951161,808019,124726,234206,536789,312197,628620,454922,1039294,537563,353223,905809,36419,769247,955638,471326,315350,2028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]