SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349335 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349335 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142209,602005,669041,652456,112544,421050,69916,993401,835522,248065,933906,247136,963029,255098,974551,802350,301361,1025695,954910,543450,894875,654928,4510,303103,556859,557336,77357,98726,155739,17180,374449,98021,356595,859576,56373,386764,698011,568289,849188,314114,485194,131731,368370,605479,487737,678348,368142,504312,280110,336101,257293,1041049,831587,72551,513638,995713,136299,106616,918747,695988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]