SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510038 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510038 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529012,502721,756176,386193,895671,63063,236848,758040,880113,548325,103850,14615,926759,65017,872081,135852,929761,418644,61077,922299,682992,212219,1033660,328247,108260,799143,743950,932231,571084,197941,33386,670072,761563,544139,246939,584985,152845,98543,350989,1019099,913130,795317,851253,184749,868351,495222,776165,885097,765043,281873,348141,953373,375192,117185,893002,978028,982299,367537,823967,562816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]