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` = 499009 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499009 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229107,218886,353121,217302,52772,420139,78126,773291,190995,245702,465808,1026818,238613,789623,175997,246335,869095,684679,794304,943325,250593,511085,365014,103214,495795,978940,114627,560614,348683,297012,234468,670155,837899,514877,200348,302886,755366,757151,341667,890591,97160,275150,270998,818716,706088,783289,925353,714559,812753,525350,790585,652253,140039,142509,526115,825886,969956,272991,60330,923813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]