SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455054 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455054 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89643,581647,11503,518493,153774,1042857,181634,142912,1025696,933486,315203,369523,904859,185780,463352,962094,150258,777209,618311,943409,556994,775610,614008,575788,812080,990293,906080,43875,716295,381129,110064,502544,82375,415525,894146,24723,830435,289135,1017261,210385,665958,919230,117313,249830,588164,71691,904779,270963,867738,845555,14914,210075,1001363,956668,640370,1029008,1764,208570,501212,942209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]