SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504943 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504943 [ RunTime:0.003719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532892,213930,824648,376965,212126,32660,235735,359192,310408,791378,640897,603535,727368,396141,658120,742015,154988,437293,56673,695587,487316,80328,15889,326628,267504,847445,799197,744559,880075,828556,327165,953476,948160,79857,763738,869057,164775,855388,635337,399519,161513,99269,649082,624554,842774,11213,917099,1006216,872770,457917,617862,982260,579640,650086,381230,268844,731439,285908,79499,998789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]