SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535327 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535327 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141804,73720,164192,458958,923391,215057,320585,831771,407639,39352,875819,110685,845643,243595,44946,118538,227122,108438,357105,769885,1031403,465472,125267,594811,991785,671698,536659,302595,23243,448661,858881,797621,992847,459333,353754,975434,982213,1034633,267342,937658,870662,12635,452829,641467,948546,456989,673222,521543,342234,934473,940109,158375,834880,765764,558404,521228,642597,280692,682990,327191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]