SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249543 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249543 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895595,704287,835358,489553,848294,800795,610218,19820,893705,254847,934756,357311,365213,38473,886700,1004419,719319,454013,650820,40365,823746,926624,7511,51371,705603,678465,60974,700742,933747,44887,394274,673645,385713,348564,52432,838597,460447,171364,654470,1022302,508182,525056,690416,816488,425374,361640,121206,914854,1026896,698729,353038,1039224,609905,826911,25561,875404,537278,773315,874395,757190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]