SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391896 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391896 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395275,487866,97185,168032,522793,741323,445569,64004,421700,886554,23426,178845,408645,345343,314639,800791,166298,801074,800235,709032,225406,577618,657958,544410,348823,657945,310298,799402,780047,712131,1001228,952697,610330,340216,902243,861211,88125,276260,247850,10124,21703,679666,535279,1024753,133510,61370,395124,777259,953895,190596,869592,202694,571979,145776,173201,385869,160389,3122,86227,45195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]