SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162872 LIMIT 1 [ RunTime:0.001348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162872 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016068,581972,369365,546783,871927,772987,501078,8743,1039610,196852,255563,458530,851016,891082,45313,585968,56819,6546,904086,131503,501391,432562,276539,422451,484754,283228,626008,141543,191020,8773,10817,944015,144898,320110,494480,415710,704480,377700,400267,498012,952314,147598,725108,465419,184383,119683,321987,205979,391440,896526,877883,898937,677269,25468,428632,480431,256198,687152,546704,960888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]