SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583507 LIMIT 1 [ RunTime:0.002236s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583507 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382155,854862,388764,635359,509246,253517,197764,625696,590401,181284,923185,862114,564473,619481,854104,227855,512869,817096,740418,618240,382764,737664,101415,482568,751050,844192,808907,702180,1047206,464720,770555,806652,820489,495947,31073,523167,295207,175267,2559,416966,895867,214036,327788,149236,678902,953761,137855,371096,616455,568259,569090,383002,405929,902042,495065,948847,87624,377307,627637,650833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]