SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444523 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444523 [ RunTime:0.004265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261379,447182,66535,239487,352017,102844,797369,95242,547613,457340,630433,352974,425087,924003,739741,677285,48330,516773,761168,152732,538479,369266,521116,396923,147537,712719,154311,431322,470161,877292,31623,108890,238341,672358,887676,102119,708728,455095,288257,878229,952627,611433,915830,906906,502791,970903,137653,418892,831242,990410,64000,410207,741011,760161,839883,758053,386773,539625,809549,513261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]